Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# PLSQL_COMPILER_FLAGS

Property | Description
--- | ---
Parameter type | String
Syntax | `PLSQL_COMPILER_FLAGS = { [ DEBUG | NON_DEBUG ] [ INTERPRETED | NATIVE ] }`
Default value | `INTERPRETED, NON_DEBUG`
Modifiable | `ALTER SESSION`, `ALTER SYSTEM`

Note: This parameter is deprecated in favor of the `PLSQL_CODE_TYPE` and `PLSQL_DEBUG` parameters. Oracle recommends that you use `PLSQL_CODE_TYPE` and `PLSQL_DEBUG` instead. `PLSQL_COMPILER_FLAGS` is retained for backward compatibility only.

`PLSQL_COMPILER_FLAGS` specifies a list of flags for the PL/SQL compiler as a comma-separated list of strings.

Values:

- `INTERPRETED`

  PL/SQL library units will be compiled to PL/SQL bytecode format. Such modules are executed by the PL/SQL interpreter engine.

- `NATIVE`

  PL/SQL library units (with the possible exception of top-level anonymous PL/SQL blocks) will be compiled to native (machine) code. Such modules will be executed natively without incurring any interpreter overhead.

- `DEBUG`

  PL/SQL library units will be compiled for debugging

- `NON_DEBUG`

  PL/SQL library units will be compiled for normal execution

The following combinations of flags are invalid specifications for the `PLSQL_COMPILER_FLAGS` parameter:

- `NATIVE` & `DEBUG`

- `NATIVE` & `INTERPRETED`

- `NON_DEBUG` & `DEBUG`

When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. The value of this parameter is stored persistently with the library unit. If a PL/SQL library unit is compiled native, all subsequent automatic recompilations of that library unit will use native compilation.